ETL Developer

2018-03-14 / Houston, TX

Possesses strong Informatica IDQ Development Skills, Data profiling, IDQ rules design and development. Should have extensive knowledge of data integration and processing including extraction, transformation, and loading (ETL). Establishes, maintains, and enforces ETL architecture design principles, techniques, standards, and best practices Design ETLs as per Business requirement like incremental loads and full loads. Understand the business requirements and developing the code according to the specification document. ‪Drives the technical design of ETL reference architecture to ensure high data quality, data integration performance, and error recovery/handling. Strong experience working with dedicated and matrixed resources as well as Informatica Power Center, Writing Complex SQL Queries, Unix Shell Scripting, Warehousing, Relational Database, BI Tools with Business Objects, ECM, Archival experience a plus Data Mapping, Data Modeling, Data Mining, and Data Warehousing/Mart, Relational databases and SQL Query performance tuning Unit test on the ETL developed code. Mapping parameters used in place of conditions and replacing the hard coded values for flexibility and reusability. Develop reusable UNIX script so that it can be used across the project. Efficient Low-level Design Documentation for the ETLs developed at mapping level. Create DB level objects like triggers, sequences, tables, history tables, procedure enhancements required for the ETL code to support. Involving in design discussions and understanding of business requirements and identify the relevant functional and technical requirements. Executing continuous improvement efforts for application design, support, and maintenance support. Preparing system documentations and participating as a reviewer and contributor in code reviews for other applications in the organization. Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.

Apply for the Job using this form