Data Engineer – Cloud
Remote East Coast – FTE/Contract
This position leads and executes product delivery in partnership with product owners,
architects, and lead engineers as part of a Scrum Team. In this position, you will help product
owners refine business and technical requirements, perform analysis on the system or
capability, test outcomes prior to launch, and partner with operations teams to ensure
supportability of the capability. The technical analyst will analyze, discover, document, and
act as a subject matter expert on the details of key customer facing capabilities, as well as
understand and document the data flow between systems that enable application
functionality. The role will work directly with our various internal and external stakeholders
including business partners, other scrum or IT teams, and external vendors.
Your goals and responsibilities will include:
Understand the business operations in detail; knowledgeable of current and possible
future practices, trends, and information affecting multiple business functions and
aspects of how they relate to other areas.
Support product owners as needed with the refinement of business requirements and
functional design specifications. Identify gaps between business requirements and
application capabilities and recommend options.
Act as a subject matter expert for functional and system capabilities. Analyze,
discover, document, and maintain functional and system designs in Customer
knowledgebase.
Understand and apply platform configurations
Worked on ETL technologies( Informatica Power Center)
Experience with Snowflake and Data Virtulisation( Denodo etc)
Responsible for design and development of Mappings, mapplets, sessions workflows and
schedule them.
Responsible for handling SCD’s in project.
Responsible for database design process, logical design, physical design, star schema,
snowflake schema etc.
Design connections objects and be well versed with session and workflow properties.
3-8 years of progressive experience with Data Warehouse and Informatica
Good programming skills – quick and self-learner and has good experience in
Informatica, ETL
Develop solution in highly demanding environment, with high performance and
availability and provide hands on guidance to other team members
Collaborate with product development teams and senior designers to develop
architectural requirements to ensure client satisfaction with Solution.
Assess requirements for completeness and accuracy and decide if they are actionable
for the ETL team,
Conduct impact assessment and determine size of effort based on requirements.
Develop full SDLC project plans to implement ETL solution and resource
identification.
Perform as active, leading role 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 develop issues.
Write SQL queries to query databases as needed for analysis into issues or system
functionality to inform design.
Understand system integration methods and data flow
Actively engage with a scrum team of developers, architects, and analysts in
delivering business requirements, technical requirements and testing for the
implemented functionalities. Work closely with the product owner throughout
delivery to ensure solution meets business needs.
Coordinate test activities with QA engineers, including: identifying task
dependencies, test schedules, creation of test data, utilization of test environments,
perform system testing.
Partner with IT Operations as needed to support resolution of issues as needed and
accept responsibility for the resolution.
As issues occur, provide data analysis and audits to identify and address root cause of
business problems and to make better informed decisions.
Experience with scheduling tools like Tidal
MUST HAVES:
Bachelor’s degree – Math, Science, Computer Science, or Business preferred or
equivalent work experience.
5+ years of experience analyzing data and understanding data ecosystems in a retail or
comparable environment.
SQL and data verification
Experience with data flow validation/ analysis through integrated systems (ETL
Testing)
Excellent analysis/troubleshooting skills, effective partnering/relationship building
skills
Experience for managing vendors to deliver components of projects
Understanding of Agile/Scrum frameworks and Waterfall methodology
Should be customer-oriented, mission focused, and a quick, continuous learner
Excellent verbal and written communication skills
Ability to communicate effectively between business and technical teams
Ability to work with and through others to resolve issues
Proven ability to work under tight deadlines and the ability to deal with ambiguity
Experienced oral and written communicator with good interpersonal skills
Positive attitude and solid work ethic
Job Features
Job Category | Developer |