Job Requirements
Job benefits
-
Medical insurance
To ensure your health and wellbeing, you have various medical plans to choose from depending on your situation and unique needs. From partial up to full medical coverage, we got you covered.
This job post is managed by
Skills
Job description for Data Engineer - Government Agency at Infocepts
- Work hand in hand with Project Managers for successful delivery of project and provide estimation, scoping and scheduling assistance
- Lead and guide development of an Informatica based ETL architecture; handle complex ETL architecture definition and design and development
- Develop solution in highly demanding environment with high performance and availability and provide hands on guidance to other team members
- Design and develop mappings, mapplets, sessions workflows and schedule them
- Responsible for the database design process, logical design, physical design, star schema, Snowflake schema etc
- Design connections objects and be well versed with session and workflow properties
- Resolve technical issues
- Perform active, leading roles in shaping and enhancing overall ETL Informatica architecture
- Identify, recommend and implement ETL process and architecture improvements
- Assist and verify design of solution and production of all design phase deliverables; identify bugs when developers are not able to do so
- Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture; resolve difficult design and development issues
- Project documentation – adheres to Quality Guidelines & Schedules
- Conduct code reviews
- 1 to 3 years of ETL development experience
- Experience with Informatica EDC and/or Axon is essential. Knowledge of other ETL tools such as DataStage will be a plus
- Expertise in performance tuning of Informatica jobs and error handling
- Knowledge of programming languages like SQL, Oracle, R, MATLAB, and Python
- Problem-solving skills
- Accuracy and attention to detail
- Adept at queries, writing reports, and making presentations
- Team-working skills
- Verbal and written communication skills
- Proven working experience in software/data engineering