Greetings from Robert,
Position: Senior Data Analyst
Location: Plano, TX
Duration: Long Term
Visa: No OPT CPT
Strong ETL background, Data Profiling Data
Modeling, EDW.
Primary Skills
1.
Expertise on Data Lineage and hands on experience on any Data lineage tools
2.
Strong knowledge on Data modeling (ERWIN tool usage)
3.
Ability to work with Client architects independently
4.
Excellent communication skills and Presentation skills
5.
Expert in SQL, DW and S2T Mappings.
6.
At least 6-8 of Data warehousing project experience
Minimum of 6+ years of hands-on experience with
the following:
Working in the following areas:
- Data
Warehousing and ETL
- Data
Marts
- Data
Profiling
- Data
Modeling
- Data
Quality Analysis
- Modeling
Dimensional Databases and Data Marts (includes physical and logical
models)
- Writing
complex SQL and stored procedures (DB2 preferred); translating
specifications and rules into SQL
- Working
with data modeling tools (Erwin preferred)
- Interpreting
and writing source to target mappings (ETL transformation rules)
- Working
with string and data manipulation functions and macros with Microsoft
Excel
- Metadata
management and data governance
- Creating
and maintaining data dictionaries
- Maintaining
and interpreting data lineages
Required Capabilities:
- Ability
to speak to the various aspect of the SDLC
- Ability
to draw out high-level and detailed designs and represent them as flow
diagrams (preferably using Visio)
- Ability
to translate business requirements into functional and technical
specifications
- Ability
to look at the given system/solution from a tool/technology-agnostic
perspective and document deterministic rules / behavior in pseudo-code
- Ability
to design end-to-end data warehousing / reporting solutions using
components like databases, ETL tools and reporting frameworks
- Ability
to provide time estimations for SA activities for a project based on the
design
- Ability
to work closely with Development, PV and UAT teams to provide them the
required support
- Ability
to perform and provide a detailed system impact analysis for a given
change request and provide estimates
- Able
to lead junior SA persons and possibly provide feedback on multiple
projects
Nice to have:
- Experience
with working on DB2 and Postgres Databases
- Experience
working with PHI & PII and sensitive data
- Knowledge
about ETL tools (preferably Ab Initio)
- Knowledge
about other Ab Initio tools like Query>IT, MDH, BRE etc.
- Knowledge
about business intelligence / analytics / tool experience – Cognos/Tableau
- Knowledge
about medical and Rx claims processing, healthcare enrollments and
providers
Knowledge and understanding of security
standards
Regards,
Robert
Platinum
Infosys Inc
Phone:
214-550-0248
Email: rob...@platinuminfosys.com