Sr. ETL Developer
Apply NowCompany: premier it Solutions
Location: Tempe, AZ 85281
Description:
Company Description
Premier IT Solutions is a leading provider of business-to-business e-commerce application implementation and integration services. Our employees are deployed in Fortune 500 companies. We work closely with companies like IBM, Cameron International, Konica Minolta, Amcor PET Packaging, Nestle, Protein Design Labs, International Paper, Zachry Corporation, NEW Corp. to name a few, in development and implementation of complete solutions in the logistics and supply chain arenas-with a focus on e-purchasing systems for both commercial and public sector organizations. Critical to the success of e-commerce initiatives is to fully integrate them with other mission-critical applications including Enterprise Resource Planning, Customer Relationship Management.
Job Description
Experience in using Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1 - Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager and Admin Console.
Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned Transformations to make them more efficient in terms of session performance.
Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings.
Instrumental in setting up standard ETL Naming standards & BEST Practices throughout the ETL process (Transformations, sessions, workflow names, log files, input, variable, output ports).
Database experience using Teradata 14.10/14, PostgreSQL, H2 Database, Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2005/2000, AS400, DB2 and MS Access. Also used SQL Editors such as Teradata SQL Assistant, H2 Console, TOAD, SQL PLUS and SQL Analyzer.
Experience on using Teradata Parallel Transporter (TPT) load protocols like LOAD, UPDATE STREAM & EXPORT.
Experience in using Teradata Macros, Query banding and BTEQ Scripts on Linux/Unix.
Strong experience using T-SQL, PL/SQL Procedures/Functions, Triggers and Packages.
Experience in Unix/Linux Operating System and Shell scripting.
Experience in integration of various data sources like Teradata, Oracle, PostgreSQL, S3, HDFS, MS SQL Server, Flat Files, and XML Definitions.
Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
Qualifications
Bachelor of Engineering
(Computer Science)
Additional Information
All your information will be kept co
Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1
Admin Console
Informatica Developer
OWB10g
Apache Spark
Azkaban
GitHub
PostgreSQL
Amazon S3
HDFS
Teradata 13.10/14/14.10/15.10
Oracle 11g/10g/9i/8i
MS SQL Server 2005/2000,
MS Access
DB2
AS400
H2 Database
SQL, PL/SQL
C, C++, Data Structures
Unix Shell Script
Teradata SQL Assistant
H2 Console
SQL plus
PL/SQL Developer
Toad
SQL* Loader
Sqoop
Windows Server 2003/2008
nfidential according to EEO guidelines.
Premier IT Solutions is a leading provider of business-to-business e-commerce application implementation and integration services. Our employees are deployed in Fortune 500 companies. We work closely with companies like IBM, Cameron International, Konica Minolta, Amcor PET Packaging, Nestle, Protein Design Labs, International Paper, Zachry Corporation, NEW Corp. to name a few, in development and implementation of complete solutions in the logistics and supply chain arenas-with a focus on e-purchasing systems for both commercial and public sector organizations. Critical to the success of e-commerce initiatives is to fully integrate them with other mission-critical applications including Enterprise Resource Planning, Customer Relationship Management.
Job Description
Experience in using Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1 - Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, Repository Manager and Admin Console.
Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Normalizer, Expression, Aggregator, Joiner, Union, Update Strategy, Stored Procedure and Sequence Generator etc.
Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3) and CDC - Change data capture.
Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned Transformations to make them more efficient in terms of session performance.
Experience in implementing the complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings.
Instrumental in setting up standard ETL Naming standards & BEST Practices throughout the ETL process (Transformations, sessions, workflow names, log files, input, variable, output ports).
Database experience using Teradata 14.10/14, PostgreSQL, H2 Database, Oracle 11g/10g/9i/8.x/7.x, MS SQL Server 2005/2000, AS400, DB2 and MS Access. Also used SQL Editors such as Teradata SQL Assistant, H2 Console, TOAD, SQL PLUS and SQL Analyzer.
Experience on using Teradata Parallel Transporter (TPT) load protocols like LOAD, UPDATE STREAM & EXPORT.
Experience in using Teradata Macros, Query banding and BTEQ Scripts on Linux/Unix.
Strong experience using T-SQL, PL/SQL Procedures/Functions, Triggers and Packages.
Experience in Unix/Linux Operating System and Shell scripting.
Experience in integration of various data sources like Teradata, Oracle, PostgreSQL, S3, HDFS, MS SQL Server, Flat Files, and XML Definitions.
Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
Qualifications
Bachelor of Engineering
(Computer Science)
Additional Information
All your information will be kept co
Informatica PowerCenter 9.6.1/9.5/9.1/8.6.1/8.1.1/7.1
Admin Console
Informatica Developer
OWB10g
Apache Spark
Azkaban
GitHub
PostgreSQL
Amazon S3
HDFS
Teradata 13.10/14/14.10/15.10
Oracle 11g/10g/9i/8i
MS SQL Server 2005/2000,
MS Access
DB2
AS400
H2 Database
SQL, PL/SQL
C, C++, Data Structures
Unix Shell Script
Teradata SQL Assistant
H2 Console
SQL plus
PL/SQL Developer
Toad
SQL* Loader
Sqoop
Windows Server 2003/2008
nfidential according to EEO guidelines.