Sr. ETL Developer

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 Additional Information Admin Console Apache Spark Unix Shell Script H2 Console All your information will be kept confidential according to EEO guidelines. #J-18808-Ljbffr premier it Solutions