Job Description :
Role: Tech Analyst for SQL with SSIS
Job Type: Fulltime/ permanent
Work Location: Atlanta, GA
Client : Infosys

JD
Participate in requirements sessions to understand source systems, data requirements. Prioritize and plan the feasibility of implementation of these requirements.
Work with BAs in the team to complete mapping documents
Design of solution and prepare Technical Design Document.
SSIS package development, Stored procedures coding, .Net scripting, Active Batch
Interact with Customer Technical team, SME’s and business analysts.
Have knowledge on TFS functionality available to understand the history and changes applied on any artifact.
Coordinate activities between onshore project team members and offshore team members
Reviews code delivered by offshore team and provides suggestions for optimization.
Unit testing of code in development environment
Support code migration, setup
Supports Integration testing and CAT testing
Coordinate and Support with active batch team and DBA team on the code migrations required in Pre-Prod and Production environment.
Monitor post production runs, analyze and solve production issues that occur as part of post-production runs
Monitor daily runs and support in case of failures in the daily run