


Their role and responsibilities require that "developers are the creative minds behind new computer software." Etl architects often use creativity in their day-to-day job, as shown by this real resume: "create sttms and mapping inventory documents along with parameters and business rules. To carry out their duties, the most important skill for an etl architect to have is creativity. You can find even more etl architect responsibilities below, including: "data warehouse," "microsoft sql server," and "data architecture" are among the most common skills that etl architects use at work. Redesign enterprise operations data mart and relate ETL supporting migration to leverage service management tool, reducing vendor cost.Perform various DataStage performance tuning techniques along with available performance analysis feature.Design and develop ETL processes using DataStage designer and sequencer.Develop data design documents including logical and physical schema models.Work on Hadoop POC to integrate all the wholesale data in Hadoop and then build a conformance layer using Hbase.Provide them with the design methodology and proper approach to the ETL mappings, UNIX scripts and store procedures.Develop a business rule configuration client tool (GUI) using java to reduce the rule implementation efforts.
#Lead software architect job description archive
Create UNIX scripts to move the interface files from interface directory to the staging and archive directories.Used T-SQL, dynamic SQL and data profiling task to profile data and render SSRS reports.Create PL/SQL packages, procedures and functions to implement the business logic and for history fix.
#Lead software architect job description code
