Shiftcodeanalytics
Informatica Developer
Shiftcodeanalytics, Chicago, Illinois, United States,
Interview : Video
Visa : USC, GC , GC EAD, H4, L2
This is hybrid from day-1 ( Need only local candidates )
Description
Need 10+ years of experience.
Job Description
We are currently searching for an Informatica Developer to join our dynamic team. In this position you will review, evaluate, design, implement, and maintain ETL Programs. You will identify data sources, construct data decomposition diagrams, and document the process. You will develop ETL programs to load the data marts & data warehouses for reporting purposes and create extract files in a structured format for other business purposes.
Analysis and Design Responsibilities
Assist in identifying entities, attributes, and relationships, define them in a complete and accurate form.Prepare technical documents to identify workflows & data flows and source & destination mappings.
Development and Implementation ResponsibilitiesDevelop ETL (Extraction, Transformation & Load) programs to load data marts and data warehouses.Create database objects, normalize tables as needed. Maintain the database referential integrity.Create accurate mapping from source to destination and ensure the data is accurately transferred.Implement the business logic by developing proper data transformations inside the workflows & data flows.Follow SDLC (System Development Life Cycle).
Testing & Quality Assurance ResponsibilitiesPerform unit, system, integration, and regression tests. Document test results and make recommendations.Validate the data thoroughly for its accuracy against the source system or other standard system reports.
Administration and Maintenance ResponsibilitiesMonitor the production jobs and make sure they are completed on-time.Perform audits regularly in accordance with company policies and correct the audit findings.
Teamwork/Collaboration ResponsibilitiesUnderstand project plans and clearly articulate roles, project goals, and timeline.Take input from supervisor, and appropriately & accurately apply the comments/feedback.Establish harmonious and effective working relationships with team members and clients.
To Be Considered, You Will Need5+ years of experience in Development and Implementation of Data warehouse & BI solutions.3+ years solid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases.2+ years of experience in ETL Development using tools like Informatica, SAP Data Service (Data Integrator).Thorough knowledge and experience in Relational & Dimensional Data Models, OLAP, Star & Snow-flake schema and experience in developing data models using Erwin, MS-VISIO.Good knowledge and experience of data warehouse architecture, design principles, practices, systems development, & analysis.Experience in developing Reporting & Analytical solutions using tools like Business Objects, Cognos, etc.
Academic BackgroundBachelor's degree in computer science or related field.
#J-18808-Ljbffr
Visa : USC, GC , GC EAD, H4, L2
This is hybrid from day-1 ( Need only local candidates )
Description
Need 10+ years of experience.
Job Description
We are currently searching for an Informatica Developer to join our dynamic team. In this position you will review, evaluate, design, implement, and maintain ETL Programs. You will identify data sources, construct data decomposition diagrams, and document the process. You will develop ETL programs to load the data marts & data warehouses for reporting purposes and create extract files in a structured format for other business purposes.
Analysis and Design Responsibilities
Assist in identifying entities, attributes, and relationships, define them in a complete and accurate form.Prepare technical documents to identify workflows & data flows and source & destination mappings.
Development and Implementation ResponsibilitiesDevelop ETL (Extraction, Transformation & Load) programs to load data marts and data warehouses.Create database objects, normalize tables as needed. Maintain the database referential integrity.Create accurate mapping from source to destination and ensure the data is accurately transferred.Implement the business logic by developing proper data transformations inside the workflows & data flows.Follow SDLC (System Development Life Cycle).
Testing & Quality Assurance ResponsibilitiesPerform unit, system, integration, and regression tests. Document test results and make recommendations.Validate the data thoroughly for its accuracy against the source system or other standard system reports.
Administration and Maintenance ResponsibilitiesMonitor the production jobs and make sure they are completed on-time.Perform audits regularly in accordance with company policies and correct the audit findings.
Teamwork/Collaboration ResponsibilitiesUnderstand project plans and clearly articulate roles, project goals, and timeline.Take input from supervisor, and appropriately & accurately apply the comments/feedback.Establish harmonious and effective working relationships with team members and clients.
To Be Considered, You Will Need5+ years of experience in Development and Implementation of Data warehouse & BI solutions.3+ years solid hands-on database development & SQL programming experience (stored procedures, triggers) using MS SQL Server, Oracle, and/or other databases.2+ years of experience in ETL Development using tools like Informatica, SAP Data Service (Data Integrator).Thorough knowledge and experience in Relational & Dimensional Data Models, OLAP, Star & Snow-flake schema and experience in developing data models using Erwin, MS-VISIO.Good knowledge and experience of data warehouse architecture, design principles, practices, systems development, & analysis.Experience in developing Reporting & Analytical solutions using tools like Business Objects, Cognos, etc.
Academic BackgroundBachelor's degree in computer science or related field.
#J-18808-Ljbffr