Role: ETL Developer
Job Location:- Alpharetta, GA
Type of Hire: Long Term.
INFORMATICA 9.6 and above
Hands On experience with Pentaho
SSRS 2012 and above
Oracle MS SQL server 2014 and above
JIRA and Confluence
Transformations like Normalizer aggregator Java Transformation
Shell scripting and commands
Excel experience with VLOOKUP and other functions
Work closely with DBAs to support and deliver application releases
Excellent analytical and problem solving skills
Experience in the health care insurance industries desired
Excellent written, verbal and interpersonal communication
Red Gate tools
SOAP Rest experience
Familiar with Logical Data Model and Physical Database design.
Strong skills in Data Analysis, Data Profiling and Data Mapping for ETL processes.
Performed analysis of Business and system requirements including Impact analysis of existing systems and create design specifications with the consultation of Business users and technical architects.
Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
Experience in database programming in TSQL
Provides support during the system implementation.
Partner with the architects to plan and develop solutions.
May work with business operations to capture metadata to build out data models.
Work with project teams to plan and execute the quality control process.
Details all aspects of functional designs, including record layouts, pseudo code, detailed data mapping, etc
Strong experience in developing Informatica PowerCenter ETL mappings using Designer, Workflow Manager, Workflow Monitor and Repository Manager
Develop ETL data work flows and code for new data integrations and maintain enhance existing workflow and code.
Experience in using complex transformations
Experience in error exception handling using Informatica mapping
Proficient in performance tuning, usage of partitions, etc.,
Preferable experience using Informatica IDQ
Report development experience must include sub reports, writing complex formulas and conditional formatting
Designs, develops and maintain various business intelligence applications reports, dashboards, scorecards
Expertized creating parameterized reports, drilldown reports and scheduled reports.
109 East 17th St, Cheyenne WY 82001
WY, MD, NJ, Noida, Hyderabad
WBE and MBE company
WY Top 50 Minority owned growing company