SAP BODS Developer with Informatica PC

Responsibilities:

• Deploys code across Dev, QA and Production environments using central repositories
• Develops/Maintains/Supports new and existing data flows from multiple source systems
• Develops/Maintains/Supports business rules and process around data cleansing, consolidation and validation, etc.
• Troubleshoots/debugs ETL and SQL query issues and provides solutions
• Develop views and ad hoc/scheduled SQL queries to analyze data, produce exception reports, validate data and as required by the functional team
• Creates ETL solutions using data warehouse design best practices, such as Star-Schema design and Change Data Capture, etc.
• Assists in the design and creation of logical and physical data models for reporting databases
• Produces data flow diagrams and other documentations and diagrams as needed
• Works with Director and Project Manager to develop and follow project plans and resource estimates. Works with Reporting team and data integration team to define and develop user data requirements
• Integrates, collaborates and leads projects, working hand in hand with Business Analysts, Data Warehouse team and DBA and the infrastructure team
• Works with functional team to assist in the preparation of source to target data maps. Work with project team and collaborate with both reporting application developers and OLTP technical leads.
• Assists in gathering/reviewing business requirements, partnering with business analysts, providing feedback on functional request feasibility and scope
• All other duties as assigned.
• Ability to work weekends and off-hours.

Required Skills:

• 4+ years' working in SAP Business Objects Data Services (BODS) - or, one of the leading enterprise ETL tools, such as Informatica PowerCenter, Microsoft SSIS, IBM InfoSphere DataStage, Pentaho or Talend - for designing and development ETL solutions.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.